Read Row
AutomatR.Excel.Activities.ReadRow
The "Read Row" activity in AutomatR is part of the Excel activities package, designed to read the values of an Excel row beginning from the cell specified in the Row Index field. This activity facilitates the extraction of row values from Excel, enhancing automation workflows involving Excel data manipulation.
Properties
| Name | Description |
|---|---|
| Input | |
| Row Index | Enter the index for the row for which values need to be retrieved. String variables containing the row index. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
| Output | |
| Result | Returns the list of strings representing the values of the selected row. List variables to store the row values. |
How to use:
- Drag and drop the "Read Row" activity onto the workflow.
- Configure the properties by specifying the row index for which values should be retrieved.
- Optionally, configure the delay.
- Execute the workflow to read values from the specified row in Excel and store them in a list variable.
Example: Consider an example where the "Read Row" activity is used to read values from the row at index "2" in an Excel worksheet:
Read Row:
Row Index: "2"
Result: ExcelRowData
In this example, the activity reads values from the specified row and stores them in the List variable "ExcelRowData" for further handling in the workflow.
Note: Ensure that the "Read Row" activity is placed within an "Excel Root" activity to establish the Excel context for execution.